package com.softeem.dao;

import com.softeem.bean.Oss;

import java.sql.SQLException;
import java.util.List;

public interface OssDao {

    public int addOss(Oss oss) throws SQLException;

    public int deleteOssId(Integer id) throws SQLException;

    public int updateOss(Oss oss) throws SQLException;

    public int updatePermission(Integer id, String permission)  throws SQLException;

    public Oss queryOssById(Integer id) throws SQLException;

    public Oss queryOssByName(String name) throws SQLException;

    public List<Oss> queryOss() throws SQLException;

    public Integer queryForPageTotalCount() throws SQLException;

    public List<Oss> queryForPageItems(int begin, int pageSize) throws SQLException;

    public Integer queryForPageTotalCount(String name, String author, Double min , Double max) throws SQLException;

    public List<Oss> queryForPageItems(int begin, int pageSize, String name, String author, Double min , Double max) throws SQLException;

}